Data type exceptions
When replicating from one Microsoft SQL Server database to another, source and target data types are identical for all supported Microsoft SQL Server versions, with the following exceptions:
| Microsoft SQL Server Source | Microsoft SQL Server Target |
|---|---|
|
DATETIME |
Supported database versions preceding Microsoft SQL Server 2016: DATETIME Microsoft SQL Server 2016 or later: DATETIME2 |
|
VARCHAR |
VARCHAR (x) (when x=0 or x>8000) else VARCHAR (max) |
|
NVARCHAR (length) |
NVARCHAR (x) (when x=0 or x>8000) else NVARCHAR (max) |
|
VARBINARY |
VARBINARY (x) (when x=0 or x>8000) else VARBINARY (max) |
|
HIERARCHYID |
VARCHAR (x) |
|
TIMESTAMP |
VARBINARY |